package com.campus_assistant.mapper.db1;

import com.campus_assistant.pojo.vo.StudentScores;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface StudentScoresMapper {
    List<StudentScores> selectStudentScoresAll();//查询全部学生成绩
    List<StudentScores> selectStudentScoreByStudentName(String studentName);//根据学生姓名查询学生成绩
    List<StudentScores> selectStudentScoreByCourseName(String courseName);//根据学科名称查询学生成绩
    List<StudentScores> selectStudentScoreByTeacherName(String teacherName);//根据教师名查询学生成绩
    StudentScores selectStudentScoreByStudentNameAndCourseName(String studentName,String courseName);//根据教师名和学科名查询学生成绩
}
